package com.geostar.constructionland.index.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.geostar.constructionland.index.entity.InxOutStorageAcotEntity;
import com.geostar.constructionland.index.entity.vo.SelInxOutStorageAcotData;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface InxOutStorageAcotMapper extends BaseMapper<InxOutStorageAcotEntity> {

/*    @Select("select * from (" +
            "select ckid as id ,zhrk.xzqhmc as distName,xmmc as projectName ,zbnf as indexYear,zbmc as indexName,zblx as indexType, " +
            "xmalx as businessType ,zbck.xzjsyd as buildLandAdd,zbck.nyd as agclLand,zbck.gd as farmland,ckzt as outStorageStatus,czsj as operatorTime, " +
            "cksj as outStorageTime, zhrk.xzqhdm_province as distCodeProvince,zhrk.xzqhdm_city as distCodeCity ,zhrk.xzqhdm_country as distCodeCountry, " +
            "zhrk.xzqhdm as distId,zhrk.rkid as inxStorageId,bpxx.ywid as businessId,bpxx.ywxl as businessSmall "+
            "from  jsyd_zbcktz zbck, jsyd_zbrktz zhrk, jsyd_bpxx bpxx  "
            + "where zbck.RKID = zhrk.RKID AND zbck.YWID = bpxx.YWID AND zbck.CKLX='xtsp' ) inxout ${ew.customSqlSegment} ")*/
    Page<SelInxOutStorageAcotData> queryInxOutStorageAcotByWrapper(
            Page page, @Param(Constants.WRAPPER) Wrapper<SelInxOutStorageAcotData> queryWrapper);

    List<SelInxOutStorageAcotData> queryInxOutStorageAcotByWrapper(@Param(Constants.WRAPPER) Wrapper<SelInxOutStorageAcotData> queryWrapper);

}
